/*
 Navicat Premium Data Transfer

 Source Server         : localhost_db
 Source Server Type    : MariaDB
 Source Server Version : 100803
 Source Host           : localhost:3306
 Source Schema         : v9

 Target Server Type    : MariaDB
 Target Server Version : 100803
 File Encoding         : 65001

 Date: 12/01/2023 17:18:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for act_evt_log
-- ----------------------------
DROP TABLE IF EXISTS `act_evt_log`;
CREATE TABLE `act_evt_log` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT current_timestamp(3) ON UPDATE current_timestamp(3),
  `USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `DATA_` longblob DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT 0,
  PRIMARY KEY (`LOG_NR_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_evt_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `BYTES_` longblob DEFAULT NULL,
  `GENERATED_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
  `NAME_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `VALUE_` varchar(300) COLLATE utf8mb3_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
BEGIN;
INSERT INTO `act_ge_property` (`NAME_`, `VALUE_`, `REV_`) VALUES ('cfg.execution-related-entities-count', 'false', 1);
INSERT INTO `act_ge_property` (`NAME_`, `VALUE_`, `REV_`) VALUES ('next.dbid', '1', 1);
INSERT INTO `act_ge_property` (`NAME_`, `VALUE_`, `REV_`) VALUES ('schema.history', 'create(7.1.0-M6)', 1);
INSERT INTO `act_ge_property` (`NAME_`, `VALUE_`, `REV_`) VALUES ('schema.version', '7.1.0-M6', 1);
COMMIT;

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `URL_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_attachment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACTION_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `FULL_MSG_` longblob DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `VAR_TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`) USING BTREE,
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`) USING BTREE,
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `VAR_TYPE_` varchar(100) COLLATE utf8mb3_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`) USING BTREE,
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_procdef_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  `ENGINE_VERSION_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `VERSION_` int(11) DEFAULT 1,
  `PROJECT_RELEASE_VERSION_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
BEGIN;
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('007eaaba-89cf-11ed-9d8c-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:22:47.773', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('00d30b6e-68df-11ed-a26d-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:24:11.913', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('034c5e4c-90da-11ed-b5ed-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 19:29:15.077', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('03cfaeec-6435-11ed-9ab2-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-14 23:57:17.832', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0448f016-88cf-11ed-ace9-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 13:50:22.973', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('05d2dcf2-6436-11ed-9775-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:04:30.704', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0669297d-90c7-11ed-883a-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 17:13:19.856', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('08f4cb71-6438-11ed-a039-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:18:54.953', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0938b9ba-88d4-11ed-b4d4-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:26:18.739', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0b01235d-88dc-11ed-9749-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 15:23:37.703', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0c7466f4-6962-11ed-943e-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-21 14:02:15.496', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('0ffae7d4-7213-11ed-9bc0-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 15:29:31.632', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('12374616-90c6-11ed-b53f-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 17:06:30.171', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('13177727-71fe-11ed-bcae-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 12:59:17.420', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('154094c9-89d0-11ed-bbd7-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:30:32.096', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1590ae6b-915e-11ed-ad21-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:14:39.295', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('16968407-7226-11ed-ae0a-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:45:43.156', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('16e0fa35-9174-11ed-b478-2a60d875fb7c', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 13:52:10.426', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1928beba-90be-11ed-918b-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 16:09:25.849', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('197882bd-8915-11ed-9f5a-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 22:12:03.287', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1a63451f-90e4-11ed-b597-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 20:41:28.782', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1abf1a75-89b9-11ed-86f0-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 17:46:02.893', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1b1e1b76-89bf-11ed-9f6b-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:29:00.494', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1b9e9745-8b86-11ed-a3ee-06afe5f98bc3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 00:46:02.344', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1c5e70c9-88b6-11ed-8680-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 10:52:05.961', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('1f6e9000-6489-11ed-a747-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 09:59:21.896', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('2020a221-7221-11ed-ab85-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:10:11.676', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('22b4a59f-9162-11ed-9d11-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:43:39.326', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('24199fd4-68e2-11ed-9221-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:46:39.584', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('269490e3-90be-11ed-8097-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 16:09:48.355', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('29066e24-8ff5-11ed-acc0-2687009f8c78', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-09 16:11:03.623', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('291c3a61-89cd-11ed-8334-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:09:36.922', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('2c2de131-9162-11ed-b8b4-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:43:55.223', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('2c81be6e-6a7d-11ed-9c25-d6fa359b83e2', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-22 23:48:56.843', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('2cb1eb98-7224-11ed-9305-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:32:01.251', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('2e499d3c-6fea-11ed-9b6a-6ada9431bdb9', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-29 21:31:50.787', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('3101ec49-8ca7-11ed-83d3-4ee4f5fdb06c', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-05 11:15:22.782', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('32442222-68c7-11ed-a07b-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 19:33:46.940', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('3296976b-89b1-11ed-9c55-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 16:49:26.917', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('338c3d1e-88da-11ed-9d08-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 15:10:26.724', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('344bee52-721e-11ed-b46b-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 16:49:17.025', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('34b63ff6-68e2-11ed-8819-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:47:07.455', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('376f8cc2-720a-11ed-a696-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 14:26:12.356', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('379bf54e-90ed-11ed-8580-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:46:43.279', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('37ebec42-68de-11ed-b8e9-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:18:34.854', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('38e5d166-8bda-11ed-9ed2-4ee4f5fdb06c', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 10:48:09.186', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('3c658e6a-721d-11ed-ad15-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 16:42:21.117', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('3f9b0aeb-89b3-11ed-a01c-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 17:04:07.751', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('41f66015-8914-11ed-9c02-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 22:06:01.724', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('43e2c909-8b1a-11ed-9f7f-868f89a740b0', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-03 11:54:04.242', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('43f24711-9161-11ed-b620-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:37:25.601', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('447ee967-63e2-11ed-ba04-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-14 14:04:58.126', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('45a64a50-89c2-11ed-a974-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:51:40.341', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('45b3e312-90e9-11ed-b46d-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:18:28.938', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('479346fb-695e-11ed-bafd-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-21 13:35:16.696', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('493d286b-7223-11ed-95e3-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:25:39.644', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('4aa7bc9b-7220-11ed-a3b8-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:04:13.529', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('4b7e3fe9-87ec-11ed-b699-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-30 10:47:26.683', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('4ca1d960-8914-11ed-b532-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 22:06:19.626', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('4e74c236-8788-11ed-b1be-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 22:51:41.984', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('4f402c50-89cd-11ed-9e0d-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:10:40.909', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('51511532-6ad5-11ed-9071-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-23 10:19:54.313', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('546b071f-90f9-11ed-9e7d-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 23:13:25.572', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('55b8c45a-9165-11ed-bae8-2a60d875fb7c', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 12:06:33.395', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('563b0292-90ed-11ed-afb9-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:47:34.654', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5a51c477-8b86-11ed-a61e-06afe5f98bc3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 00:47:47.539', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5a7f0144-89b2-11ed-a4ec-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 16:57:43.367', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5b3a60b5-6435-11ed-8e19-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-14 23:59:44.493', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5e51429c-89d0-11ed-bdbd-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:32:34.677', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5f849c1b-88ce-11ed-8ad1-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 13:45:46.526', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('5f9b1cf5-68df-11ed-ae94-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:26:50.930', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('639d6aa8-69ae-11ed-8d54-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-21 23:08:43.477', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('65b28a7a-880f-11ed-8e9f-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-30 14:58:43.034', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('675b82d3-6a7d-11ed-a6e1-d6fa359b83e2', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-22 23:50:35.580', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('6a16c21e-90da-11ed-99cc-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 19:32:07.532', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('6c54f75a-90c8-11ed-851b-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 17:23:20.354', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('6c872c78-90bd-11ed-a7ff-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 16:04:36.220', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('6da48cce-89c0-11ed-824e-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:38:28.443', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('6f1b16e6-90e5-11ed-94f5-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 20:51:00.411', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('77f846f1-90ea-11ed-8037-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:27:02.766', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('7888a4da-89cf-11ed-aeaf-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:26:09.165', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('791f55b0-7220-11ed-a81c-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:05:31.489', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('7b20c789-68d2-11ed-b501-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 20:54:33.648', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('7b2278b1-8c12-11ed-9cc8-86f318e7b74b', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 17:30:52.135', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('7cfaf142-6a7d-11ed-899a-d6fa359b83e2', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-22 23:51:11.856', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('840b6e16-9161-11ed-bff2-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:39:13.137', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8791e7b0-915f-11ed-89ee-965455bb3d66', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-11 11:25:00.060', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8a045cc6-88d0-11ed-97ab-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:01:16.834', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8b345465-90bb-11ed-87a5-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 15:51:08.688', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8b9c8be2-8ca8-11ed-8eed-4ee4f5fdb06c', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-05 11:25:04.287', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8e960dc5-89c3-11ed-b721-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 19:00:52.205', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('8f5fd56f-6435-11ed-af90-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:01:11.980', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('90eeef36-89bf-11ed-8ce6-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:32:18.157', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('95bcf8fa-880f-11ed-a683-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-30 15:00:03.629', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('992d8af6-89c3-11ed-a591-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 19:01:09.971', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('99762aba-8fee-11ed-8531-2687009f8c78', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-09 15:24:05.777', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('99a11623-8916-11ed-a510-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 22:22:47.786', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9b2eaebe-89bf-11ed-abc0-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:32:35.351', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9c38b1ef-89cf-11ed-9bc9-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:27:09.032', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9d083408-89c0-11ed-86d8-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:39:47.952', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9d5434c9-88db-11ed-90d1-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 15:20:33.699', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9e90f01c-6942-11ed-a2f1-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-21 10:17:16.736', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('9fc16818-90c6-11ed-aaf7-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 17:10:27.632', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('a720284d-6435-11ed-88c1-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:01:51.828', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('a97746db-6ad8-11ed-94cb-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-23 10:43:50.694', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('b04164c6-89cd-11ed-a8b6-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:13:23.660', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('b2998fc7-8f2a-11ed-ab3a-6e17b7d20a67', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-08 16:01:46.598', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('bdf3e88c-8c0f-11ed-b4be-86f318e7b74b', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 17:11:15.747', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('be39d9c4-6435-11ed-9361-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:02:30.584', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('be55a673-88d1-11ed-a00c-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:09:54.108', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('bf8374ce-88d8-11ed-8953-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 15:00:02.559', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('c1a94ccc-6437-11ed-ada3-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:16:55.340', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('c2e52fd4-8834-11ed-9f0f-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-30 19:26:10.772', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('c45be932-90ed-11ed-9c80-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:50:39.418', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('c509d8f4-88d2-11ed-bd45-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:17:14.850', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('cb51c1ea-89cc-11ed-b41d-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:06:59.569', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('cbc2a0ce-89b1-11ed-a924-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 16:53:43.898', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('cdb763df-89bf-11ed-a3e5-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 18:34:00.133', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('cf6e2071-68df-11ed-a998-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:29:58.538', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('cfa2a69c-8780-11ed-a0e3-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 21:58:02.736', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('d2a2055f-88cd-11ed-a5b0-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 13:41:50.173', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('d447a215-88d1-11ed-8c60-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:10:30.924', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('d79b5972-6435-11ed-a53a-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 00:03:13.165', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('d846f843-6434-11ed-9b37-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-14 23:56:04.795', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('d894a3ff-89b1-11ed-a2d0-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 16:54:05.406', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('da141744-6a79-11ed-b355-9a1f43ee34f5', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-22 23:25:10.062', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('da270f4a-8913-11ed-9b37-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 22:03:07.547', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('dacafea8-8785-11ed-b395-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 22:34:08.941', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('dc40a929-90ec-11ed-b795-220e408b124f', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-10 21:44:10.009', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('dfdfa4fa-721c-11ed-91d7-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 16:39:45.890', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e0ff763c-89ce-11ed-9dfb-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 20:21:54.929', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e236640d-8b85-11ed-bf71-06afe5f98bc3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 00:44:26.032', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e3c243b3-8786-11ed-88d4-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 22:41:33.477', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e42ee376-8b86-11ed-beb5-06afe5f98bc3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-04 00:51:38.829', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e4f5ae4e-88ce-11ed-8062-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 13:49:30.417', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('e6089418-8787-11ed-bb25-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 22:48:46.791', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('eae7a4ac-6489-11ed-acb0-9a0c3074b3ea', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-15 10:05:03.266', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('ecfec031-68de-11ed-95a0-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:23:38.644', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('f3662279-88d2-11ed-b0ee-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-31 14:18:32.631', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('f4d0bac9-878a-11ed-8d46-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-29 23:10:40.082', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('f9353198-7226-11ed-b9ca-eea17cda91ad', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-02 17:52:03.360', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('fc6952f7-68df-11ed-8604-3ed49fd157b7', 'SpringAutoDeployment', NULL, NULL, '', '2022-11-20 22:31:14.006', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('fc997c1f-89b0-11ed-92c6-32dfe800b8b3', 'SpringAutoDeployment', NULL, NULL, '', '2023-01-01 16:47:56.338', NULL, 1, NULL);
INSERT INTO `act_re_deployment` (`ID_`, `NAME_`, `CATEGORY_`, `KEY_`, `TENANT_ID_`, `DEPLOY_TIME_`, `ENGINE_VERSION_`, `VERSION_`, `PROJECT_RELEASE_VERSION_`) VALUES ('fe88ed1b-87ff-11ed-bbeb-0a4a3f7db038', 'SpringAutoDeployment', NULL, NULL, '', '2022-12-30 13:08:27.504', NULL, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `META_INFO_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) USING BTREE,
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_re_model
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `VERSION_` int(11) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  `ENGINE_VERSION_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_deadletter_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_deadletter_job`;
CREATE TABLE `act_ru_deadletter_job` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`) USING BTREE,
  KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_DEADLETTER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_deadletter_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `EVENT_NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT current_timestamp(3),
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`) USING BTREE,
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_event_subscr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_MI_ROOT_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `START_TIME_` datetime(3) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL,
  `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL,
  `TASK_COUNT_` int(11) DEFAULT NULL,
  `JOB_COUNT_` int(11) DEFAULT NULL,
  `TIMER_JOB_COUNT_` int(11) DEFAULT NULL,
  `SUSP_JOB_COUNT_` int(11) DEFAULT NULL,
  `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL,
  `VAR_COUNT_` int(11) DEFAULT NULL,
  `ID_LINK_COUNT_` int(11) DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`) USING BTREE,
  KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`) USING BTREE,
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`) USING BTREE,
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`) USING BTREE,
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`) USING BTREE,
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`) USING BTREE,
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_integration
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_integration`;
CREATE TABLE `act_ru_integration` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `FLOW_NODE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `CREATED_DATE_` timestamp(3) NOT NULL DEFAULT current_timestamp(3) ON UPDATE current_timestamp(3),
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_INT_EXECUTION` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_INT_PROC_INST` (`PROCESS_INSTANCE_ID_`) USING BTREE,
  KEY `ACT_FK_INT_PROC_DEF` (`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_integration
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`) USING BTREE,
  KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_suspended_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_suspended_job`;
CREATE TABLE `act_ru_suspended_job` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`) USING BTREE,
  KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_SUSPENDED_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_suspended_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  `FORM_KEY_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`) USING BTREE,
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_task
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_timer_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_timer_job`;
CREATE TABLE `act_ru_timer_job` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8mb3_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8mb3_bin DEFAULT '',
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`) USING BTREE,
  KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`) USING BTREE,
  KEY `ACT_FK_TIMER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_timer_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
  `ID_` varchar(64) COLLATE utf8mb3_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`) USING BTREE,
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`) USING BTREE,
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`) USING BTREE,
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fl_biz_type
-- ----------------------------
DROP TABLE IF EXISTS `fl_biz_type`;
CREATE TABLE `fl_biz_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `seq` int(11) DEFAULT NULL COMMENT '排序',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of fl_biz_type
-- ----------------------------
BEGIN;
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (1, '假勤管理', '2022-12-30 10:29:49', '2022-12-30 10:29:49', 0, 0, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (2, '人事管理', '2022-12-30 14:05:22', '2022-12-30 14:05:22', 0, 1, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (3, '智能财务', '2022-12-30 14:29:58', '2022-12-30 14:29:58', 0, 2, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (4, '法务管理', '2022-12-30 15:01:31', '2022-12-30 15:01:31', 0, 3, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (5, '行政管理', '2022-12-30 15:01:41', '2022-12-30 15:01:41', 0, 4, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (6, '客户管理', '2022-12-30 15:02:01', '2022-12-30 15:02:01', 0, 5, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (7, '业务管理', '2022-12-30 15:02:20', '2022-12-30 15:02:20', 0, 6, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (8, '安全复工', '2022-12-30 15:02:34', '2022-12-30 15:02:34', 0, 7, NULL);
INSERT INTO `fl_biz_type` (`id`, `name`, `create_time`, `update_time`, `del_status`, `seq`, `parent_id`) VALUES (9, '其它', '2022-12-30 15:02:52', '2022-12-30 15:02:52', 0, 99, NULL);
COMMIT;

-- ----------------------------
-- Table structure for fl_flow_info
-- ----------------------------
DROP TABLE IF EXISTS `fl_flow_info`;
CREATE TABLE `fl_flow_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '名称',
  `biz_type_id` bigint(20) DEFAULT NULL COMMENT '业务类型',
  `content` text DEFAULT NULL COMMENT '内容',
  `remark` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '备注',
  `dep_status` tinyint(4) DEFAULT NULL COMMENT '发布状态',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '编码',
  `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '图标地址',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `group_id` bigint(20) DEFAULT NULL COMMENT '创建组Id',
  `all_user` tinyint(4) DEFAULT NULL COMMENT '发启者内型是否分部人员，否则参考引用关系 FlowSponsor',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of fl_flow_info
-- ----------------------------
BEGIN;
INSERT INTO `fl_flow_info` (`id`, `name`, `biz_type_id`, `content`, `remark`, `dep_status`, `code`, `icon`, `create_time`, `update_time`, `del_status`, `group_id`, `all_user`) VALUES (6, '请假', 1, '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<bpmn:definitions xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:bpmn=\"http://www.omg.org/spec/BPMN/20100524/MODEL\" xmlns:bpmndi=\"http://www.omg.org/spec/BPMN/20100524/DI\" xmlns:dc=\"http://www.omg.org/spec/DD/20100524/DC\" xmlns:di=\"http://www.omg.org/spec/DD/20100524/DI\" id=\"Definitions_0v7t65f\" targetNamespace=\"http://bpmn.io/schema/bpmn\">\n  <bpmn:process id=\"qj\" name=\"请假\" isExecutable=\"true\">\n    <bpmn:sequenceFlow id=\"Flow_1uezggd\" sourceRef=\"Activity_03d1k92\" targetRef=\"Event_1qlm1tb\" />\n    <bpmn:sequenceFlow id=\"Flow_0oov8mb\" sourceRef=\"Activity_0au7beq\" targetRef=\"Activity_03d1k92\" />\n    <bpmn:sequenceFlow id=\"Flow_0k0uh5e\" sourceRef=\"Activity_0grrcqu\" targetRef=\"Activity_03d1k92\" />\n    <bpmn:sequenceFlow id=\"Flow_05de1ts\" name=\"请假&#62;1天\" sourceRef=\"Gateway_0wkew51\" targetRef=\"Activity_0au7beq\" />\n    <bpmn:sequenceFlow id=\"Flow_1utkswv\" name=\"请假&#60;=1天\" sourceRef=\"Gateway_0wkew51\" targetRef=\"Activity_0grrcqu\" />\n    <bpmn:sequenceFlow id=\"Flow_16yfrb3\" sourceRef=\"Event_1gcb081\" targetRef=\"Gateway_0wkew51\" />\n    <bpmn:endEvent id=\"Event_1qlm1tb\" name=\"结束\">\n      <bpmn:incoming>Flow_1uezggd</bpmn:incoming>\n    </bpmn:endEvent>\n    <bpmn:userTask id=\"Activity_0au7beq\" name=\"总经理审批\">\n      <bpmn:incoming>Flow_05de1ts</bpmn:incoming>\n      <bpmn:outgoing>Flow_0oov8mb</bpmn:outgoing>\n    </bpmn:userTask>\n    <bpmn:userTask id=\"Activity_0grrcqu\" name=\"部门经理审批\">\n      <bpmn:incoming>Flow_1utkswv</bpmn:incoming>\n      <bpmn:outgoing>Flow_0k0uh5e</bpmn:outgoing>\n    </bpmn:userTask>\n    <bpmn:exclusiveGateway id=\"Gateway_0wkew51\">\n      <bpmn:incoming>Flow_16yfrb3</bpmn:incoming>\n      <bpmn:outgoing>Flow_05de1ts</bpmn:outgoing>\n      <bpmn:outgoing>Flow_1utkswv</bpmn:outgoing>\n    </bpmn:exclusiveGateway>\n    <bpmn:startEvent id=\"Event_1gcb081\" name=\"发起人\">\n      <bpmn:outgoing>Flow_16yfrb3</bpmn:outgoing>\n    </bpmn:startEvent>\n    <bpmn:sendTask id=\"Activity_03d1k92\" name=\"抄送HR\">\n      <bpmn:incoming>Flow_0oov8mb</bpmn:incoming>\n      <bpmn:incoming>Flow_0k0uh5e</bpmn:incoming>\n      <bpmn:outgoing>Flow_1uezggd</bpmn:outgoing>\n    </bpmn:sendTask>\n  </bpmn:process>\n  <bpmndi:BPMNDiagram id=\"BPMNDiagram_1\">\n    <bpmndi:BPMNPlane id=\"code_di\" bpmnElement=\"qj\">\n      <bpmndi:BPMNShape id=\"Event_1qlm1tb_di\" bpmnElement=\"Event_1qlm1tb\">\n        <dc:Bounds x=\"752\" y=\"472\" width=\"36\" height=\"36\" />\n        <bpmndi:BPMNLabel>\n          <dc:Bounds x=\"759\" y=\"515\" width=\"22\" height=\"14\" />\n        </bpmndi:BPMNLabel>\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNShape id=\"Activity_0au7beq_di\" bpmnElement=\"Activity_0au7beq\">\n        <dc:Bounds x=\"880\" y=\"230\" width=\"100\" height=\"80\" />\n        <bpmndi:BPMNLabel />\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNShape id=\"Activity_0grrcqu_di\" bpmnElement=\"Activity_0grrcqu\">\n        <dc:Bounds x=\"570\" y=\"230\" width=\"100\" height=\"80\" />\n        <bpmndi:BPMNLabel />\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNShape id=\"Gateway_0wkew51_di\" bpmnElement=\"Gateway_0wkew51\" isMarkerVisible=\"true\">\n        <dc:Bounds x=\"745\" y=\"155\" width=\"50\" height=\"50\" />\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNShape id=\"Event_1gcb081_di\" bpmnElement=\"Event_1gcb081\">\n        <dc:Bounds x=\"752\" y=\"72\" width=\"36\" height=\"36\" />\n        <bpmndi:BPMNLabel>\n          <dc:Bounds x=\"753\" y=\"48\" width=\"33\" height=\"14\" />\n        </bpmndi:BPMNLabel>\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNShape id=\"Activity_0ep5ksa_di\" bpmnElement=\"Activity_03d1k92\">\n        <dc:Bounds x=\"720\" y=\"340\" width=\"100\" height=\"80\" />\n        <bpmndi:BPMNLabel />\n      </bpmndi:BPMNShape>\n      <bpmndi:BPMNEdge id=\"Flow_1uezggd_di\" bpmnElement=\"Flow_1uezggd\">\n        <di:waypoint x=\"770\" y=\"420\" />\n        <di:waypoint x=\"770\" y=\"472\" />\n      </bpmndi:BPMNEdge>\n      <bpmndi:BPMNEdge id=\"Flow_0oov8mb_di\" bpmnElement=\"Flow_0oov8mb\">\n        <di:waypoint x=\"930\" y=\"310\" />\n        <di:waypoint x=\"930\" y=\"380\" />\n        <di:waypoint x=\"820\" y=\"380\" />\n      </bpmndi:BPMNEdge>\n      <bpmndi:BPMNEdge id=\"Flow_0k0uh5e_di\" bpmnElement=\"Flow_0k0uh5e\">\n        <di:waypoint x=\"620\" y=\"310\" />\n        <di:waypoint x=\"620\" y=\"380\" />\n        <di:waypoint x=\"720\" y=\"380\" />\n      </bpmndi:BPMNEdge>\n      <bpmndi:BPMNEdge id=\"Flow_05de1ts_di\" bpmnElement=\"Flow_05de1ts\">\n        <di:waypoint x=\"795\" y=\"180\" />\n        <di:waypoint x=\"930\" y=\"180\" />\n        <di:waypoint x=\"930\" y=\"230\" />\n        <bpmndi:BPMNLabel>\n          <dc:Bounds x=\"841\" y=\"162\" width=\"46\" height=\"14\" />\n        </bpmndi:BPMNLabel>\n      </bpmndi:BPMNEdge>\n      <bpmndi:BPMNEdge id=\"Flow_1utkswv_di\" bpmnElement=\"Flow_1utkswv\">\n        <di:waypoint x=\"745\" y=\"180\" />\n        <di:waypoint x=\"620\" y=\"180\" />\n        <di:waypoint x=\"620\" y=\"230\" />\n        <bpmndi:BPMNLabel>\n          <dc:Bounds x=\"655\" y=\"162\" width=\"52\" height=\"14\" />\n        </bpmndi:BPMNLabel>\n      </bpmndi:BPMNEdge>\n      <bpmndi:BPMNEdge id=\"Flow_16yfrb3_di\" bpmnElement=\"Flow_16yfrb3\">\n        <di:waypoint x=\"770\" y=\"108\" />\n        <di:waypoint x=\"770\" y=\"155\" />\n      </bpmndi:BPMNEdge>\n    </bpmndi:BPMNPlane>\n  </bpmndi:BPMNDiagram>\n</bpmn:definitions>\n', NULL, 0, 'qj', '/common/upload/2023/01/10/202301102301897A001', '2023-01-10 23:14:39', '2023-01-10 23:14:39', 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for fl_page
-- ----------------------------
DROP TABLE IF EXISTS `fl_page`;
CREATE TABLE `fl_page` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `flow_id` bigint(20) NOT NULL COMMENT '流程id',
  `task_id` varchar(32) NOT NULL COMMENT '任务id',
  `name` varchar(32) DEFAULT NULL COMMENT '表单名称',
  `title` varchar(32) DEFAULT NULL COMMENT '表单标题',
  `content` text DEFAULT NULL COMMENT '内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of fl_page
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fl_sponsor
-- ----------------------------
DROP TABLE IF EXISTS `fl_sponsor`;
CREATE TABLE `fl_sponsor` (
  `flow_id` bigint(20) NOT NULL,
  `type` varchar(32) NOT NULL COMMENT '发启者类型',
  `ref_id` varchar(32) NOT NULL COMMENT '引用id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of fl_sponsor
-- ----------------------------
BEGIN;
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (1, 'role', '2');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (1, 'role', '23');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (2, 'dept', '1');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (3, 'dept', '1');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (4, 'dept', '1');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (5, 'dept', '1');
INSERT INTO `fl_sponsor` (`flow_id`, `type`, `ref_id`) VALUES (6, 'dept', '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_application
-- ----------------------------
DROP TABLE IF EXISTS `sys_application`;
CREATE TABLE `sys_application` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(32) NOT NULL COMMENT '应用名称',
  `description` varchar(32) DEFAULT NULL COMMENT '应用描述',
  `code` varchar(32) NOT NULL COMMENT '应用编码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_application
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_application_release
-- ----------------------------
DROP TABLE IF EXISTS `sys_application_release`;
CREATE TABLE `sys_application_release` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `application_id` bigint(20) NOT NULL COMMENT '应用ID',
  `version_number` varchar(32) NOT NULL COMMENT '版本号',
  `update_content` varchar(256) DEFAULT NULL COMMENT '更新内容',
  `download_link` varchar(1024) NOT NULL COMMENT '下载地址',
  `current_version` tinyint(4) NOT NULL COMMENT '是否为当前启用版本',
  `force_update` tinyint(4) NOT NULL COMMENT '是否强制更新',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_application_release
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_code_table
-- ----------------------------
DROP TABLE IF EXISTS `sys_code_table`;
CREATE TABLE `sys_code_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `code_type` varchar(32) NOT NULL COMMENT '码表类型',
  `name` varchar(32) NOT NULL COMMENT '编码名称',
  `value` varchar(32) NOT NULL COMMENT '值',
  `remark` varchar(32) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `code` varchar(32) NOT NULL COMMENT '编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_code_table
-- ----------------------------
BEGIN;
INSERT INTO `sys_code_table` (`id`, `code_type`, `name`, `value`, `remark`, `create_time`, `update_time`, `del_status`, `code`) VALUES (1, 'ttt', 'erfgd', 'fdsfd', 'av', '2022-10-27 01:10:55', '2022-10-27 01:10:55', 0, 'fdsfd');
COMMIT;

-- ----------------------------
-- Table structure for sys_code_table_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_code_table_type`;
CREATE TABLE `sys_code_table_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `code` varchar(32) NOT NULL COMMENT '码表编码',
  `name` varchar(32) NOT NULL COMMENT '名称',
  `remark` varchar(64) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_code_table_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_code_table_type` (`id`, `code`, `name`, `remark`, `create_time`, `update_time`, `del_status`) VALUES (1, 'position', '岗位', '岗位', '2022-10-26 21:25:42', '2022-10-26 21:25:42', 0);
INSERT INTO `sys_code_table_type` (`id`, `code`, `name`, `remark`, `create_time`, `update_time`, `del_status`) VALUES (2, 'ttt', 'test', 'fff', '2022-10-26 21:44:07', '2022-10-26 21:44:07', 0);
INSERT INTO `sys_code_table_type` (`id`, `code`, `name`, `remark`, `create_time`, `update_time`, `del_status`) VALUES (3, 'qjlx', '请假类型', '请假类型', '2023-01-11 11:28:15', '2023-01-11 11:28:15', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '名称',
  `key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '键',
  `value` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '值',
  `system` tinyint(4) DEFAULT NULL COMMENT '系统内置',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父部门ID',
  `name` varchar(32) DEFAULT NULL COMMENT '部门名称',
  `seq` int(11) DEFAULT NULL COMMENT '显示顺序',
  `leader` varchar(32) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(32) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(32) DEFAULT NULL COMMENT '邮箱',
  `status` tinyint(4) DEFAULT NULL COMMENT '部门状态',
  `ids` varchar(32) DEFAULT NULL COMMENT '扩展id，用于搜索',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `parent_id`, `name`, `seq`, `leader`, `phone`, `email`, `status`, `ids`, `create_time`, `update_time`, `del_status`) VALUES (1, NULL, 'V9总部', 1, 'V9', '13888888888', 'lunshi@v9.cn', 1, NULL, '2023-01-01 16:59:58', '2023-01-01 16:59:58', 0);
INSERT INTO `sys_dept` (`id`, `parent_id`, `name`, `seq`, `leader`, `phone`, `email`, `status`, `ids`, `create_time`, `update_time`, `del_status`) VALUES (2, 1, '成都分公司', 1, 'v9', NULL, 'cd@v9.cn', 1, '1', '2023-01-01 17:00:49', '2023-01-01 17:00:49', 0);
INSERT INTO `sys_dept` (`id`, `parent_id`, `name`, `seq`, `leader`, `phone`, `email`, `status`, `ids`, `create_time`, `update_time`, `del_status`) VALUES (3, 1, '北京分公司', 2, 'v9', NULL, 'bj@v9.cn', 1, '1', '2023-01-01 17:01:19', '2023-01-01 17:01:19', 0);
INSERT INTO `sys_dept` (`id`, `parent_id`, `name`, `seq`, `leader`, `phone`, `email`, `status`, `ids`, `create_time`, `update_time`, `del_status`) VALUES (4, 2, '开发部', 1, 'v9', NULL, NULL, 1, '1|2', '2023-01-01 18:52:44', '2023-01-01 18:52:44', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `parent_id` bigint(20) DEFAULT 0 COMMENT '父菜单ID',
  `seq` int(11) DEFAULT NULL,
  `path` varchar(32) DEFAULT NULL,
  `component` varchar(64) DEFAULT NULL COMMENT '路径',
  `query` varchar(32) DEFAULT NULL,
  `is_frame` tinyint(4) DEFAULT 1 COMMENT '是否为外链（0是 1否）',
  `is_cache` tinyint(4) DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` varchar(32) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` tinyint(4) DEFAULT 0 COMMENT '菜单状态（0显示 1隐藏）',
  `status` tinyint(4) DEFAULT 0 COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(32) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `del_status` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2011 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1, '系统管理', 0, 95, 'system', NULL, '', 0, 0, 'M', 1, 1, '', 'system', '2022-12-07 15:38:44', '2022-12-19 00:06:13', '系统管理目录', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 0, 0, 'C', 1, 1, 'system:user:list', 'user', '2022-12-07 15:38:44', NULL, '用户管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 0, 0, 'C', 1, 1, 'system:role:list', 'peoples', '2022-12-07 15:38:44', NULL, '角色管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (102, '菜单管理', 1, 4, 'menu', 'system/menu/index', '', 0, 0, 'C', 1, 1, 'system:menu:list', 'tree-table', '2022-12-07 15:38:44', NULL, '菜单管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (103, '部门管理', 1, 5, 'dept', 'system/dept/index', '', 0, 0, 'C', 1, 1, 'system:dept:list', 'tree', '2022-12-07 15:38:44', NULL, '部门管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (104, '岗位管理', 1, 6, 'post', 'system/post/index', '', 0, 0, 'C', 1, 1, 'system:post:list', 'post', '2022-12-07 15:38:44', NULL, '岗位管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (105, '字典管理', 1, 7, 'dict', 'system/dict/index', '', 0, 0, 'C', 1, 1, 'system:dict:list', 'dict', '2022-12-07 15:38:44', NULL, '字典管理菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 0, 0, 'C', 1, 1, 'system:notice:list', 'message', '2022-12-07 15:38:44', NULL, '通知公告菜单', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1000, '用户查询', 100, 1, '', '', '', 0, 0, 'F', 1, 1, 'system:user:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1001, '用户新增', 100, 2, '', '', '', 0, 0, 'F', 1, 1, 'system:user:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1002, '用户修改', 100, 3, '', '', '', 0, 0, 'F', 1, 1, 'system:user:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1003, '用户删除', 100, 4, '', '', '', 0, 0, 'F', 1, 1, 'system:user:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1004, '用户导出', 100, 5, '', '', '', 0, 0, 'F', 1, 1, 'system:user:export', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1005, '用户导入', 100, 6, '', '', '', 0, 0, 'F', 1, 1, 'system:user:import', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1006, '重置密码', 100, 7, '', '', '', 0, 0, 'F', 1, 1, 'system:user:resetPwd', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1007, '角色查询', 101, 1, '', '', '', 0, 0, 'F', 1, 1, 'system:role:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1008, '角色新增', 101, 2, '', '', '', 0, 0, 'F', 1, 1, 'system:role:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1009, '角色修改', 101, 3, '', '', '', 0, 0, 'F', 1, 1, 'system:role:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1010, '角色删除', 101, 4, '', '', '', 0, 0, 'F', 1, 1, 'system:role:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1011, '角色导出', 101, 5, '', '', '', 0, 0, 'F', 1, 1, 'system:role:export', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1012, '菜单查询', 102, 1, '', '', '', 0, 0, 'F', 1, 1, 'system:menu:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1013, '菜单新增', 102, 2, '', '', '', 0, 0, 'F', 1, 1, 'system:menu:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1014, '菜单修改', 102, 3, '', '', '', 0, 0, 'F', 1, 1, 'system:menu:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1015, '菜单删除', 102, 4, '', '', '', 0, 0, 'F', 1, 1, 'system:menu:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1016, '部门查询', 103, 1, '', '', '', 0, 0, 'F', 1, 1, 'system:dept:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1017, '部门新增', 103, 2, '', '', '', 0, 0, 'F', 1, 1, 'system:dept:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1018, '部门修改', 103, 3, '', '', '', 0, 0, 'F', 1, 1, 'system:dept:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1019, '部门删除', 103, 4, '', '', '', 0, 0, 'F', 1, 1, 'system:dept:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1020, '岗位查询', 104, 1, '', '', '', 0, 0, 'F', 1, 1, 'system:post:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1021, '岗位新增', 104, 2, '', '', '', 0, 0, 'F', 1, 1, 'system:post:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1022, '岗位修改', 104, 3, '', '', '', 0, 0, 'F', 1, 1, 'system:post:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1023, '岗位删除', 104, 4, '', '', '', 0, 0, 'F', 1, 1, 'system:post:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1024, '岗位导出', 104, 5, '', '', '', 0, 0, 'F', 1, 1, 'system:post:export', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1025, '字典查询', 105, 1, '#', '', '', 0, 0, 'F', 1, 1, 'system:dict:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1026, '字典新增', 105, 2, '#', '', '', 0, 0, 'F', 1, 1, 'system:dict:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1027, '字典修改', 105, 3, '#', '', '', 0, 0, 'F', 1, 1, 'system:dict:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1028, '字典删除', 105, 4, '#', '', '', 0, 0, 'F', 1, 1, 'system:dict:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1035, '公告查询', 107, 1, '#', '', '', 0, 0, 'F', 1, 1, 'system:notice:query', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1036, '公告新增', 107, 2, '#', '', '', 0, 0, 'F', 1, 1, 'system:notice:add', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1037, '公告修改', 107, 3, '#', '', '', 0, 0, 'F', 1, 1, 'system:notice:edit', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (1038, '公告删除', 107, 4, '#', '', '', 0, 0, 'F', 1, 1, 'system:notice:remove', '#', '2022-12-07 15:38:44', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (2000, '工作流管理', 0, 99, 'flow', NULL, NULL, 0, 0, 'M', 1, 1, NULL, 'druid', '2022-12-08 19:37:24', NULL, '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (2001, '流程分类', 2000, 1, 'flow/type', 'flow/type/index', NULL, 0, 0, 'C', 1, 1, 'flow:config', 'form', '2022-12-08 19:38:03', '2022-12-10 13:16:54', '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (2005, '流程管理', 2000, 3, 'flow/info', 'flow/info/info', '', 0, 0, 'C', 1, 1, 'flow:config', 'table', '2022-12-11 10:46:54', '2022-12-19 21:50:57', '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (2006, '工作流设计器', 2000, 4, 'flow/editor/:id', 'flow/info/editor', '', 0, 0, 'C', 0, 0, 'flow:config', 'edit', '2022-12-11 21:57:20', '2022-12-14 17:45:31', '', 0);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `seq`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_time`, `update_time`, `remark`, `del_status`) VALUES (2010, '角色类型', 1, 3, 'role/type', 'system/role/roleType', NULL, 0, 1, 'C', 1, 1, 'system:role:list', 'nested', '2023-01-04 17:10:33', '2023-01-04 17:10:33', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '是否缓存 ',
  `notice_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '公告类型 ',
  `content` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '公告状态 ',
  `status` tinyint(4) DEFAULT NULL COMMENT '公告状态 ',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_operator_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operator_log`;
CREATE TABLE `sys_operator_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '操作模块',
  `business_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '业务类型',
  `method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '请求方法',
  `request_method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '请求方法',
  `operator_type` int(11) DEFAULT NULL COMMENT '操作类别',
  `oper_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '操作人员',
  `dept_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '部门名称',
  `url` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '请求url',
  `ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '操作地址',
  `location` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '操作地点',
  `params` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '请求参数',
  `json_result` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '返回参数',
  `status` tinyint(4) DEFAULT NULL COMMENT '操作是否正常',
  `error_msg` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '错误消息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_operator_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_position
-- ----------------------------
DROP TABLE IF EXISTS `sys_position`;
CREATE TABLE `sys_position` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(32) DEFAULT NULL COMMENT '岗位名称',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '部门id',
  `seq` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(4) DEFAULT NULL COMMENT '启用状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `code` varchar(32) DEFAULT NULL COMMENT '岗位编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_position
-- ----------------------------
BEGIN;
INSERT INTO `sys_position` (`id`, `name`, `dept_id`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `code`) VALUES (1, '人事经理', '0c25c02c039b6595d31cfd2649216e42', 1, 1, '2022-10-22 08:03:36', '2022-10-22 08:03:36', 0, 'hr');
INSERT INTO `sys_position` (`id`, `name`, `dept_id`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `code`) VALUES (3, '部门经理', NULL, 1, 1, '2022-11-15 00:19:34', '2022-11-15 00:19:34', 0, 'jl');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `code` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '权限编码',
  `seq` int(11) DEFAULT NULL COMMENT '角色排序',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `role_type_id` bigint(20) DEFAULT NULL COMMENT '角色类型Id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (1, '负者人', '超级管理员111', 'fzr', 1, 1, NULL, NULL, 0, 1);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (2, '主管', '专注java开发三十年', 'ee', 2, 1, NULL, NULL, 0, 1);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (23, '管理员', NULL, 'admin', 3, 1, '2023-01-05 11:57:18', '2023-01-05 11:57:18', 0, 1);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (24, '行政', NULL, NULL, 4, 1, '2023-01-05 12:03:34', '2023-01-05 12:03:34', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (25, '财务', NULL, NULL, 5, 1, '2023-01-05 12:04:01', '2023-01-05 12:04:01', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (26, '人事', NULL, NULL, 6, 1, '2023-01-05 12:04:30', '2023-01-05 12:04:30', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (27, 'IT', NULL, NULL, 7, 1, '2023-01-05 12:04:53', '2023-01-05 12:04:53', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (28, '市场', NULL, NULL, 8, 1, '2023-01-05 12:05:18', '2023-01-05 12:05:18', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (29, '运营', NULL, NULL, 9, 1, '2023-01-05 12:05:39', '2023-01-05 12:05:39', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (30, '销售', NULL, NULL, 10, 1, '2023-01-05 12:06:26', '2023-01-05 12:06:26', 0, 2);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (31, '普通员工', NULL, NULL, 11, 1, '2023-01-05 12:07:13', '2023-01-05 12:07:13', 0, 3);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (32, '经理', NULL, NULL, 11, 1, '2023-01-05 12:08:11', '2023-01-05 12:08:11', 0, 3);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (34, '懂事长', NULL, NULL, 12, 1, '2023-01-05 12:09:12', '2023-01-05 12:09:12', 0, 3);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (35, '总监', NULL, NULL, 13, 1, '2023-01-05 12:09:30', '2023-01-05 12:09:30', 0, 3);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (36, '管理层', NULL, NULL, 14, 1, '2023-01-05 12:09:53', '2023-01-05 12:09:53', 0, 3);
INSERT INTO `sys_role` (`id`, `name`, `remark`, `code`, `seq`, `status`, `create_time`, `update_time`, `del_status`, `role_type_id`) VALUES (37, '总经理', NULL, NULL, 15, 1, '2023-01-05 12:11:02', '2023-01-05 12:11:02', 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 100);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 101);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 103);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 104);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 105);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 106);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 107);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_type`;
CREATE TABLE `sys_role_type` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(32) DEFAULT NULL COMMENT '名称',
  `seq` int(11) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_role_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_type` (`id`, `name`, `seq`, `create_time`, `update_time`, `del_status`) VALUES (1, '默认', 1, '2023-01-04 17:24:28', '2023-01-04 17:24:28', 0);
INSERT INTO `sys_role_type` (`id`, `name`, `seq`, `create_time`, `update_time`, `del_status`) VALUES (2, '职务', 2, '2023-01-04 17:24:43', '2023-01-04 17:24:43', 0);
INSERT INTO `sys_role_type` (`id`, `name`, `seq`, `create_time`, `update_time`, `del_status`) VALUES (3, '岗位', 3, '2023-01-04 17:24:53', '2023-01-04 17:24:53', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_upload
-- ----------------------------
DROP TABLE IF EXISTS `sys_upload`;
CREATE TABLE `sys_upload` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `name` varchar(32) NOT NULL COMMENT '文件原名',
  `file_size` decimal(16,6) DEFAULT NULL COMMENT '文件大小kb',
  `path` varchar(128) DEFAULT NULL COMMENT '路径',
  `file_type_code` varchar(32) NOT NULL COMMENT '文件类型编码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_upload
-- ----------------------------
BEGIN;
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (10, 'bus.jpg', 491687.000000, '/Users/lunshi/temp/v9/upload/2022/12/31/2022123651412985A001', 'JPG', NULL, NULL, NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (11, 'WechatIMG115.jpeg', 657948.000000, '2022/12/31/202212365151290A001', 'JPG', '2022-12-31 15:01:22', '2022-12-31 15:01:22', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (12, 'bus.jpg', 491687.000000, '2022/12/31/2022123651512830A001', 'JPG', '2022-12-31 15:11:30', '2022-12-31 15:11:30', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (13, 'bus.jpg', 491687.000000, '2022/12/31/2022123651512837A002', 'JPG', '2022-12-31 15:11:44', '2022-12-31 15:11:44', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (14, 'WechatIMG115.jpeg', 657948.000000, '2022/12/31/2022123651512234A001', 'JPG', '2022-12-31 15:21:31', '2022-12-31 15:21:31', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (15, 'WechatIMG115.jpeg', 657948.000000, '2022/12/31/2022123651512396A001', 'JPG', '2022-12-31 15:23:53', '2022-12-31 15:23:53', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (16, 'bus.jpg', 491687.000000, '2022/12/31/202212365151283A002', 'JPG', '2022-12-31 15:28:27', '2022-12-31 15:28:27', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (17, 'bus.jpg', 491687.000000, '2022/12/31/2022123651512982A003', 'JPG', '2022-12-31 15:29:23', '2022-12-31 15:29:23', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (18, 'bus.jpg', 491687.000000, '2022/12/31/2022123651512831A004', 'JPG', '2022-12-31 15:31:40', '2022-12-31 15:31:40', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (19, 'WechatIMG86.jpeg', 132694.000000, '2022/12/31/2022123651512379A005', 'JPG', '2022-12-31 15:32:31', '2022-12-31 15:32:31', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (20, 'bus.jpg', 491687.000000, '2022/12/31/2022123651512869A006', 'JPG', '2022-12-31 15:34:14', '2022-12-31 15:34:14', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (21, 'WechatIMG115.jpeg', 657948.000000, '2022/12/31/2022123651512981A007', 'JPG', '2022-12-31 15:34:24', '2022-12-31 15:34:24', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (22, 'bus.jpg', 491687.000000, '2022/12/31/2022123652112173A008', 'JPG', '2022-12-31 21:59:10', '2022-12-31 21:59:10', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (23, 'bus.jpg', 491687.000000, '2022/12/31/2022123652212171A001', 'JPG', '2022-12-31 22:03:58', '2022-12-31 22:03:58', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (24, 'bus.jpg', 491687.000000, '2022/12/31/2022123652212286A001', 'JPG', '2022-12-31 22:12:58', '2022-12-31 22:12:58', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (25, 'bus.jpg', 491687.000000, '2022/12/31/2022123652212352A002', 'JPG', '2022-12-31 22:17:44', '2022-12-31 22:17:44', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (26, 'WechatIMG86.jpeg', 132694.000000, '2022/12/31/2022123652212559A003', 'JPG', '2022-12-31 22:18:38', '2022-12-31 22:18:38', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (27, 'WechatIMG86.jpeg', 132694.000000, '2022/12/31/2022123652212363A004', 'JPG', '2022-12-31 22:21:31', '2022-12-31 22:21:31', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (28, 'bus.jpg', 491687.000000, '2022/12/31/2022123652212335A001', 'JPG', '2022-12-31 22:22:56', '2022-12-31 22:22:56', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (29, 'bus.jpg', 491687.000000, '2023/01/01/202301012001919A001', 'JPG', '2023-01-01 20:38:37', '2023-01-01 20:38:37', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (30, 'bus.jpg', 491687.000000, '2023/01/10/202301102001295A001', 'JPG', '2023-01-10 20:54:13', '2023-01-10 20:54:13', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (31, 'bus.jpg', 491687.000000, '2023/01/10/202301102101678A001', 'JPG', '2023-01-10 21:27:38', '2023-01-10 21:27:38', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (32, 'bus.jpg', 491687.000000, '2023/01/10/202301102101131A002', 'JPG', '2023-01-10 21:28:22', '2023-01-10 21:28:22', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (33, 'bus.jpg', 491687.000000, '2023/01/10/20230110210186A001', 'JPG', '2023-01-10 21:48:41', '2023-01-10 21:48:41', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (34, 'bus.jpg', 491687.000000, '2023/01/10/202301102101125A001', 'JPG', '2023-01-10 21:51:14', '2023-01-10 21:51:14', NULL);
INSERT INTO `sys_upload` (`id`, `name`, `file_size`, `path`, `file_type_code`, `create_time`, `update_time`, `del_status`) VALUES (35, 'bus.jpg', 491687.000000, '2023/01/10/202301102301897A001', 'JPG', '2023-01-10 23:14:22', '2023-01-10 23:14:22', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_info`;
CREATE TABLE `sys_user_info` (
  `id` varchar(32) NOT NULL COMMENT '标识',
  `username` varchar(32) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '密码',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `position_id` bigint(20) DEFAULT NULL COMMENT '岗位',
  `nick_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '用户邮箱',
  `email` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '用户邮箱',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '手机号码',
  `gender_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '用户性别',
  `avatar` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '用户头像',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `login_ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci DEFAULT NULL COMMENT '状态',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `real_name` varchar(32) DEFAULT NULL COMMENT '真实名称',
  `sign` varchar(64) DEFAULT NULL COMMENT '签名',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `icon` varchar(128) DEFAULT NULL COMMENT '用户头像',
  `remark` text DEFAULT NULL,
  `dept_ids` varchar(32) DEFAULT NULL COMMENT '扩展部门id，用于搜索',
  `job_number` varchar(32) DEFAULT NULL COMMENT '工号',
  `entry_time` datetime DEFAULT NULL COMMENT '入职时间',
  `educational_background` varchar(32) DEFAULT NULL COMMENT '学历',
  `seq` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_info` (`id`, `username`, `password`, `dept_id`, `position_id`, `nick_name`, `email`, `phone`, `gender_type`, `avatar`, `status`, `login_ip`, `login_date`, `create_time`, `update_time`, `del_status`, `real_name`, `sign`, `birthday`, `icon`, `remark`, `dept_ids`, `job_number`, `entry_time`, `educational_background`, `seq`) VALUES ('05ff012119ed14a357d00eae9ceb91dc', 'admin', '0192023a7bbd73250516f069df18b500', 4, 3, 'aaa', 'eeee@qq.com', '13541370905', 'WOMAN', NULL, 1, '127.0.0.1', '2023-01-11 10:39:59', '2022-10-24 09:14:45', '2022-10-24 09:14:45', 0, '管理员', 'fdsafdsfdsafdsfdsafdsfdsafdsfdsafdsfdsafdsfdsafdsfdsafdsfdsafdsf', '2022-12-21 00:00:00', 'http://image.rankeiot.com/img/ea9da4e0f033c39fbb0f6ce1c2418cb9', 'egfdgfghdsgfdsgfds', '1|2|4', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `role_id` bigint(20) DEFAULT NULL,
  `pin` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_status` tinyint(4) DEFAULT NULL COMMENT '创建时间',
  `id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`role_id`, `pin`, `create_time`, `update_time`, `del_status`, `id`) VALUES (1, '05ff012119ed14a357d00eae9ceb91dc', NULL, NULL, NULL, NULL);
INSERT INTO `sys_user_role` (`role_id`, `pin`, `create_time`, `update_time`, `del_status`, `id`) VALUES (2, '05ff012119ed14a357d00eae9ceb91dc', NULL, NULL, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
